load data
infile 'D:\Userdata\db\visits.csv'
replace
INTO table visits
fields terminated by "," optionally enclosed by '"'
trailing nullcols
 (vnum char "TRIM (:vnum)"
 , vdate date "MMDDYYYY"
 , vtype char "TRIM (:vtype)"
 , vcomments char "TRIM (:vcomments)"
 , pemail char "TRIM (:pemail)"
 , cemail char "TRIM (:cemail)"
 , nstudents char "TRIM (:nstudents)"
 , cvisited char "TRIM (:cvisited)"
 , scode char "TRIM (:scode)"
 )